Close message Scootle is currently experiencing a technical issue which may affect logging in for some users. Scootle resources can still be accessed via Guest login. For any questions, please contact [email protected]

Search results

Listed under:  Mathematics  >  Statistics and probability  >  Data representation  >  Spreadsheets
Text

Assessment: Australian Curriculum: Digital Technologies sample Data assessment tasks: years 7-8

Resource description This resource provides strategies for assessing students' understanding of the ways in which data can be sourced, organised and represented to maximise options for analysis, evaluation, decomposition and visualisation in order to create digital solutions. The context of the resource is the liveability ...

Video

Computational thinking in the Australian Curriculum: Digital Technologies

This video provides an overview of computational thinking and how it can be taught in the context of other learning areas.

Online

Turtles: impact of climate change on Flatback turtle populations

The lesson follows an inquiry process in which students use a dataset to answer relevant questions about the turtle population. They consider how to analyse and display the data in order to effectively examine the impact of rising global temperatures on flatback turtle populations.

Online

Creating my own spreadsheet to convert binary to decimal

A spreadsheet can be used to do calculations quickly using formulas. How can we make a spreadsheet that converts a binary number to a decimal number? This lesson provides some guidance and Excel files for student and teacher use.

Online

Seeing the wood for the trees

In this lesson sequence students summarise data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases.

Online

Who wants to be a millionaire?

This lesson sequence uses the well-known wheat/rice and chessboard problem as students use spreadsheets to simulate iteration and to solve problems.

Online

COVID 19 Demystified course

At the end of this course, learners should be able to better understand the science and numbers behindCOVID-19 and the SARS-CoV-2 virus that causes it. They should be able to discuss the pandemic with confidence, giving substantiated viewpoints on matters such as public policy with a willingness to accept other viewpoints. ...

Text

Books for exploring Digital Technologies concepts

This PDF provides a list of suggested books or similar that identify and discuss key concepts, key ideas and related ways of thinking about Digital Technologies.

Video

DTiF Classroom Exploring AI in the Classroom: Activity

Simon Collier, Digital Technologies in Focus Curriculum Officer, takes viewers though a lesson from the Digital Technologies Hub exploring how machine learning can be used to organise photographs.

Text

Digital Technologies resource types and resource mapping template

This three-page document gives suggestions for selecting and organising Digital Technologies resources, including physical equipment, unplugged activities and online links. It includes a simple template that may be helpful in documenting these.

Text

Effective DTiF strategies

This PDF lists eight ways in which Digital Technologies in Focus (DTiF) supported the implementation of Digital Technologies in disadvantaged schools.

Video

Supporting implementation of Digital Technologies and the ICT Capability: part 1

This video explains ways in which the Digital Technologies curriculum and the Information and Communication Technology (ICT) General Capability can be implemented in schools. This video is the first in a series of three.

Text

Newsletter – April 2019

This newsletter from the Digital Technologies in Focus project includes information about school projects, data representation, the Australian Curriculum, and useful resources.

Text

Alyangula Area School

Alyangula Area School is a government school located in Alyangula on Groote Eylandt, in the Northern Territory on the Traditional Lands of the Anindilyakwa People. Martin Levins is one of ACARA’s curriculum officers who works directly with the school to support the implementation of the Australian Curriculum: Digital Technologies. ...

Text

Kelley & Knowles review: STEM integration

This article explores ways of building integrated STEM programs so that students have opportunities to make connections to crosscutting concepts and real-world problems. This is proposed through the lens of a framework.

Video

Expert webinar video: Dr Karen Joyce: Map my school

Dr Karen Joyce from STEM education provider She Maps discusses geospatial mapping and methods for teaching underpinning concepts to primary, secondary and tertiary students. Her presentation provides opportunities to think about how we might teach digital systems, data collection and interpretation to our students in context.

Video

Expert webinar video: Dr Rebecca Vivian - The CSER Digital Technologies Education Program

Dr Rebecca Vivian provides an overview of the CSER Digital Technologies Education Project from The University of Adelaide. The project includes free professional learning, a digital equipment lending library and a range of resources designed to support teachers in the implementation of the Australian Curriculum: Digital ...

Video

Supporting implementation of Digital Technologies and the ICT Capability: part 2

This video explains ways in which the Digital Technologies curriculum and the Information and Communication Technology (ICT) General Capability can be implemented in schools. This video is the second in a series of three.

Text

St James Catholic College

St James Catholic College is a K–10 school located about 50 kilometres south of Hobart, Tasmania on the Traditional Lands of the Mellukurdee Peoples. Peter Lelong is the curriculum officer who works directly with the school to support the implementation of the Digital Technologies curriculum. Teachers at the school have ...

Video

Data knowledge and skills tutorial: part 1 - gathering data

This video demonstrates ways in which data can be manipulated in spreadsheets. It is the first in a series of four.